from django.db import models

# Create your models here.

# class TmsInventory(models.Model):
#     prline = models.CharField(db_column='Prline', max_length=255, blank=True, null=True)  # Field name made lowercase.
#     supplier = models.CharField(max_length=255, blank=True, null=True)
#     tool_number = models.CharField(max_length=255, blank=True, null=True)
#     tool_type = models.CharField(max_length=255, blank=True, null=True)
#     tool_life = models.CharField(max_length=255, blank=True, null=True)
#     tool_status = models.CharField(max_length=255, blank=True, null=True)
#     cutting_edge = models.CharField(max_length=255, blank=True, null=True)
#     teeth_number = models.CharField(max_length=255, blank=True, null=True)
#     notes = models.CharField(max_length=255, blank=True, null=True)
#     process_number = models.CharField(max_length=255, blank=True, null=True)
#     storage_location = models.CharField(max_length=255, blank=True, null=True)
#     inventory_quantity = models.IntegerField(blank=True, null=True)
#     add_inventory_time = models.DateTimeField(blank=True, null=True)
#     last_out_invent_time = models.DateTimeField(blank=True, null=True)
#     lead_time = models.IntegerField(blank=True, null=True, db_comment='交货周期')
#     safety_factor = models.IntegerField(blank=True, null=True, db_comment='安全系数')
#     approval_time = models.IntegerField(blank=True, null=True, db_comment='审批时间')
#     m_replace_q = models.IntegerField(blank=True, null=True, db_comment='月更换数量')
#     min_invent_q = models.IntegerField(blank=True, null=True, db_comment='最小库存数量')

#     class Meta:
#         managed = False
#         db_table = 'tms_inventory'


class TmsInventory(models.Model):
    prline = models.CharField(db_column='Prline', max_length=255, blank=True, null=True, db_comment='������')  # Field name made lowercase.
    supplier = models.CharField(max_length=255, blank=True, null=True, db_comment='��Ӧ��')
    purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ���')
    bak_purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���òɹ���')
    tool_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���ߺ�')
    tool_type = models.CharField(max_length=255, blank=True, null=True, db_comment='��������')
    tool_life = models.IntegerField(blank=True, null=True, db_comment='��������')
    tool_status = models.CharField(max_length=255, blank=True, null=True, db_comment='����״̬')
    cutting_edge = models.IntegerField(blank=True, null=True, db_comment='�п�')
    teeth_number = models.IntegerField(blank=True, null=True, db_comment='����')
    notes = models.CharField(max_length=255, blank=True, null=True, db_comment='��ע')
    process_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�����')
    storage_location = models.CharField(max_length=255, blank=True, null=True, db_comment='�ִ�λ��')
    inventory_quantity = models.IntegerField(blank=True, null=True, db_comment='�������')
    tool_unit_price = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True, db_comment='�µ��ߵ���')
    coping_tool_unit_price = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True, db_comment='��ĥ������')
    inventory_amount = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True, db_comment='�����')
    add_inventory_time = models.DateTimeField(blank=True, null=True, db_comment='���ʱ��')
    last_out_invent_time = models.DateTimeField(blank=True, null=True, db_comment='�������ʱ��')
    lead_time = models.FloatField(blank=True, null=True, db_comment='��������')
    safety_factor = models.FloatField(blank=True, null=True, db_comment='��ȫϵ��')
    approval_time = models.FloatField(blank=True, null=True, db_comment='����ʱ��')
    m_replace_q = models.FloatField(blank=True, null=True, db_comment='�¸�������')
    min_invent_q = models.FloatField(blank=True, null=True, db_comment='��С�������')
    actual_tool_life = models.IntegerField(blank=True, null=True, db_comment='ʵ�ʵ�������')
    purchase_status = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ�״̬')
    purchased_number = models.IntegerField(blank=True, null=True, db_comment='�ѷ���ɹ�������')

    class Meta:
        managed = False
        db_table = 'tms_inventory'
        
        
# 入库记录表     
class TmsAddInventoryLog(models.Model):
    prline = models.CharField(db_column='Prline', max_length=255, blank=True, null=True)  # Field name made lowercase.
    supplier = models.CharField(max_length=255, blank=True, null=True)
    tool_number = models.CharField(max_length=255, blank=True, null=True)
    purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ���')
    bak_purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���òɹ���')
    tool_type = models.CharField(max_length=255, blank=True, null=True)
    tool_life = models.IntegerField(blank=True, null=True)
    tool_status = models.CharField(max_length=255, blank=True, null=True)
    cutting_edge = models.IntegerField(blank=True, null=True)
    teeth_number = models.IntegerField(blank=True, null=True)
    notes = models.CharField(max_length=255, blank=True, null=True)
    process_number = models.CharField(max_length=255, blank=True, null=True)
    storage_location = models.CharField(max_length=255, blank=True, null=True)
    inventory_quantity = models.IntegerField(blank=True, null=True)
    add_inventory_time = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'tms_add_inventory_log'


# 出库记录表

class TmsOutInventoryLog(models.Model):
    prline = models.CharField(db_column='Prline', max_length=255, blank=True, null=True)  # Field name made lowercase.
    supplier = models.CharField(max_length=255, blank=True, null=True)
    tool_number = models.CharField(max_length=255, blank=True, null=True)
    purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ���')
    bak_purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���òɹ���')
    tool_type = models.CharField(max_length=255, blank=True, null=True)
    tool_life = models.IntegerField(blank=True, null=True)
    tool_status = models.CharField(max_length=255, blank=True, null=True)
    cutting_edge = models.IntegerField(blank=True, null=True)
    teeth_number = models.IntegerField(blank=True, null=True)
    notes = models.CharField(max_length=255, blank=True, null=True)
    process_number = models.CharField(max_length=255, blank=True, null=True)
    storage_location = models.CharField(max_length=255, blank=True, null=True)
    inventory_quantity = models.IntegerField(blank=True, null=True)
    out_inventory_time = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'tms_out_inventory_log'



# 物料信息表  
class TmsMaterialInfo(models.Model):
    prline = models.CharField(db_column='Prline', max_length=255, blank=True, null=True)  # Field name made lowercase.
    purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ���')
    bak_purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���òɹ���')
    supplier = models.CharField(max_length=255, blank=True, null=True)
    tool_number = models.CharField(max_length=255, blank=True, null=True)
    tool_type = models.CharField(max_length=255, blank=True, null=True)
    tool_life = models.IntegerField(blank=True, null=True)
    cutting_edge = models.IntegerField(blank=True, null=True)
    teeth_number = models.IntegerField(blank=True, null=True)
    tool_unit_price = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True, db_comment='�µ��ߵ���')
    coping_tool_unit_price = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True, db_comment='��ĥ������')
    notes = models.CharField(max_length=255, blank=True, null=True)
    material_add_time = models.DateTimeField(db_column='material_add__time', blank=True, null=True)  # Field renamed because it contained more than one '_' in a row.

    class Meta:
        managed = False
        db_table = 'tms_material_info'



# 采购记录表

class TmsPurchaseList(models.Model):
    supplier = models.CharField(max_length=255, blank=True, null=True, db_comment='��Ӧ��')
    purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ���')
    bak_purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���òɹ���')
    tool_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���ߺ�')
    tool_type = models.CharField(max_length=255, blank=True, null=True, db_comment='�����ͺ�')
    tool_life = models.IntegerField(blank=True, null=True, db_comment='��������')
    tool_status = models.CharField(max_length=255, blank=True, null=True, db_comment='����״̬���µ�����ĥ��')
    cutting_edge = models.IntegerField(blank=True, null=True, db_comment='�п�')
    teeth_number = models.IntegerField(blank=True, null=True, db_comment='����')
    notes = models.CharField(max_length=255, blank=True, null=True, db_comment='��ע')
    inventory_quantity = models.IntegerField(blank=True, null=True, db_comment='�������')
    lead_time = models.FloatField(blank=True, null=True, db_comment='��������')
    safety_factor = models.FloatField(blank=True, null=True, db_comment='��ȫϵ��')
    approval_time = models.FloatField(blank=True, null=True, db_comment='����ʱ��')
    m_replace_q = models.FloatField(blank=True, null=True, db_comment='�¸�������')
    min_invent_q = models.FloatField(blank=True, null=True, db_comment='��С�������')
    actual_tool_life = models.IntegerField(blank=True, null=True, db_comment='ʵ�ʵ�������')
    purchase_time = models.DateTimeField(blank=True, null=True, db_comment='����ɹ�ʱ��')
    purchase_quantity = models.IntegerField(blank=True, null=True, db_comment='�ɹ�����')
    purchase_status = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ�״̬��δ�ɹ����ɹ��У��ѵ���')

    class Meta:
        managed = False
        db_table = 'tms_purchase_list'
        
        
# 宝骏数据模型

class TmsInventoryBj(models.Model):
    prline = models.CharField(db_column='Prline', max_length=255, blank=True, null=True, db_comment='������')  # Field name made lowercase.
    supplier = models.CharField(max_length=255, blank=True, null=True, db_comment='��Ӧ��')
    purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ���')
    bak_purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���òɹ���')
    tool_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���ߺ�')
    tool_type = models.CharField(max_length=255, blank=True, null=True, db_comment='��������')
    tool_life = models.IntegerField(blank=True, null=True, db_comment='��������')
    tool_status = models.CharField(max_length=255, blank=True, null=True, db_comment='����״̬')
    cutting_edge = models.IntegerField(blank=True, null=True, db_comment='�п�')
    teeth_number = models.IntegerField(blank=True, null=True, db_comment='����')
    notes = models.CharField(max_length=255, blank=True, null=True, db_comment='��ע')
    process_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�����')
    storage_location = models.CharField(max_length=255, blank=True, null=True, db_comment='�ִ�λ��')
    inventory_quantity = models.IntegerField(blank=True, null=True, db_comment='�������')
    tool_unit_price = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True, db_comment='�µ��ߵ���')
    coping_tool_unit_price = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True, db_comment='��ĥ������')
    inventory_amount = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True, db_comment='�����')
    add_inventory_time = models.DateTimeField(blank=True, null=True, db_comment='���ʱ��')
    last_out_invent_time = models.DateTimeField(blank=True, null=True, db_comment='�������ʱ��')
    lead_time = models.FloatField(blank=True, null=True, db_comment='��������')
    safety_factor = models.FloatField(blank=True, null=True, db_comment='��ȫϵ��')
    approval_time = models.FloatField(blank=True, null=True, db_comment='����ʱ��')
    m_replace_q = models.FloatField(blank=True, null=True, db_comment='�¸�������')
    min_invent_q = models.FloatField(blank=True, null=True, db_comment='��С�������')
    actual_tool_life = models.IntegerField(blank=True, null=True, db_comment='ʵ�ʵ�������')
    purchase_status = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ�״̬')
    purchased_number = models.IntegerField(blank=True, null=True, db_comment='�ѷ���ɹ�������')

    class Meta:
        managed = False
        db_table = 'tms_inventory_bj'
        
class TmsMaterialInfoBj(models.Model):
    prline = models.CharField(db_column='Prline', max_length=255, blank=True, null=True)  # Field name made lowercase.
    purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ���')
    bak_purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���òɹ���')
    supplier = models.CharField(max_length=255, blank=True, null=True)
    tool_number = models.CharField(max_length=255, blank=True, null=True)
    tool_type = models.CharField(max_length=255, blank=True, null=True)
    tool_life = models.IntegerField(blank=True, null=True)
    cutting_edge = models.IntegerField(blank=True, null=True)
    teeth_number = models.IntegerField(blank=True, null=True)
    tool_unit_price = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True, db_comment='�µ��ߵ���')
    coping_tool_unit_price = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True, db_comment='��ĥ������')
    notes = models.CharField(max_length=255, blank=True, null=True)
    material_add_time = models.DateTimeField(db_column='material_add__time', blank=True, null=True)  # Field renamed because it contained more than one '_' in a row.

    class Meta:
        managed = False
        db_table = 'tms_material_info_bj'


class TmsPurchaseListBj(models.Model):
    supplier = models.CharField(max_length=255, blank=True, null=True, db_comment='��Ӧ��')
    purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ���')
    bak_purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���òɹ���')
    tool_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���ߺ�')
    tool_type = models.CharField(max_length=255, blank=True, null=True, db_comment='�����ͺ�')
    tool_life = models.IntegerField(blank=True, null=True, db_comment='��������')
    tool_status = models.CharField(max_length=255, blank=True, null=True, db_comment='����״̬���µ�����ĥ��')
    cutting_edge = models.IntegerField(blank=True, null=True, db_comment='�п�')
    teeth_number = models.IntegerField(blank=True, null=True, db_comment='����')
    notes = models.CharField(max_length=255, blank=True, null=True, db_comment='��ע')
    inventory_quantity = models.IntegerField(blank=True, null=True, db_comment='�������')
    lead_time = models.FloatField(blank=True, null=True, db_comment='��������')
    safety_factor = models.FloatField(blank=True, null=True, db_comment='��ȫϵ��')
    approval_time = models.FloatField(blank=True, null=True, db_comment='����ʱ��')
    m_replace_q = models.FloatField(blank=True, null=True, db_comment='�¸�������')
    min_invent_q = models.FloatField(blank=True, null=True, db_comment='��С�������')
    actual_tool_life = models.IntegerField(blank=True, null=True, db_comment='ʵ�ʵ�������')
    purchase_time = models.DateTimeField(blank=True, null=True, db_comment='����ɹ�ʱ��')
    purchase_quantity = models.IntegerField(blank=True, null=True, db_comment='�ɹ�����')
    purchase_status = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ�״̬��δ�ɹ����ɹ��У��ѵ���')

    class Meta:
        managed = False
        db_table = 'tms_purchase_list_bj'


class TmsAddInventoryLogBj(models.Model):
    prline = models.CharField(db_column='Prline', max_length=255, blank=True, null=True)  # Field name made lowercase.
    supplier = models.CharField(max_length=255, blank=True, null=True)
    tool_number = models.CharField(max_length=255, blank=True, null=True)
    purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ���')
    bak_purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���òɹ���')
    tool_type = models.CharField(max_length=255, blank=True, null=True)
    tool_life = models.IntegerField(blank=True, null=True)
    tool_status = models.CharField(max_length=255, blank=True, null=True)
    cutting_edge = models.IntegerField(blank=True, null=True)
    teeth_number = models.IntegerField(blank=True, null=True)
    notes = models.CharField(max_length=255, blank=True, null=True)
    process_number = models.CharField(max_length=255, blank=True, null=True)
    storage_location = models.CharField(max_length=255, blank=True, null=True)
    inventory_quantity = models.IntegerField(blank=True, null=True)
    add_inventory_time = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'tms_add_inventory_log_bj'


class TmsOutInventoryLogBj(models.Model):
    prline = models.CharField(db_column='Prline', max_length=255, blank=True, null=True)  # Field name made lowercase.
    supplier = models.CharField(max_length=255, blank=True, null=True)
    tool_number = models.CharField(max_length=255, blank=True, null=True)
    purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ���')
    bak_purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���òɹ���')
    tool_type = models.CharField(max_length=255, blank=True, null=True)
    tool_life = models.IntegerField(blank=True, null=True)
    tool_status = models.CharField(max_length=255, blank=True, null=True)
    cutting_edge = models.IntegerField(blank=True, null=True)
    teeth_number = models.IntegerField(blank=True, null=True)
    notes = models.CharField(max_length=255, blank=True, null=True)
    process_number = models.CharField(max_length=255, blank=True, null=True)
    storage_location = models.CharField(max_length=255, blank=True, null=True)
    inventory_quantity = models.IntegerField(blank=True, null=True)
    out_inventory_time = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'tms_out_inventory_log_bj'


# 青岛数据模型
class TmsInventoryQd(models.Model):
    prline = models.CharField(db_column='Prline', max_length=255, blank=True, null=True, db_comment='������')  # Field name made lowercase.
    supplier = models.CharField(max_length=255, blank=True, null=True, db_comment='��Ӧ��')
    purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ���')
    bak_purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���òɹ���')
    tool_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���ߺ�')
    tool_type = models.CharField(max_length=255, blank=True, null=True, db_comment='��������')
    tool_life = models.IntegerField(blank=True, null=True, db_comment='��������')
    tool_status = models.CharField(max_length=255, blank=True, null=True, db_comment='����״̬')
    cutting_edge = models.IntegerField(blank=True, null=True, db_comment='�п�')
    teeth_number = models.IntegerField(blank=True, null=True, db_comment='����')
    notes = models.CharField(max_length=255, blank=True, null=True, db_comment='��ע')
    process_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�����')
    storage_location = models.CharField(max_length=255, blank=True, null=True, db_comment='�ִ�λ��')
    inventory_quantity = models.IntegerField(blank=True, null=True, db_comment='�������')
    tool_unit_price = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True, db_comment='�µ��ߵ���')
    coping_tool_unit_price = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True, db_comment='��ĥ������')
    inventory_amount = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True, db_comment='�����')
    add_inventory_time = models.DateTimeField(blank=True, null=True, db_comment='���ʱ��')
    last_out_invent_time = models.DateTimeField(blank=True, null=True, db_comment='�������ʱ��')
    lead_time = models.FloatField(blank=True, null=True, db_comment='��������')
    safety_factor = models.FloatField(blank=True, null=True, db_comment='��ȫϵ��')
    approval_time = models.FloatField(blank=True, null=True, db_comment='����ʱ��')
    m_replace_q = models.FloatField(blank=True, null=True, db_comment='�¸�������')
    min_invent_q = models.FloatField(blank=True, null=True, db_comment='��С�������')
    actual_tool_life = models.IntegerField(blank=True, null=True, db_comment='ʵ�ʵ�������')
    purchase_status = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ�״̬')
    purchased_number = models.IntegerField(blank=True, null=True, db_comment='�ѷ���ɹ�������')

    class Meta:
        managed = False
        db_table = 'tms_inventory_qd'
        
class TmsMaterialInfoQd(models.Model):
    prline = models.CharField(db_column='Prline', max_length=255, blank=True, null=True)  # Field name made lowercase.
    purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ���')
    bak_purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���òɹ���')
    supplier = models.CharField(max_length=255, blank=True, null=True)
    tool_number = models.CharField(max_length=255, blank=True, null=True)
    tool_type = models.CharField(max_length=255, blank=True, null=True)
    tool_life = models.IntegerField(blank=True, null=True)
    cutting_edge = models.IntegerField(blank=True, null=True)
    teeth_number = models.IntegerField(blank=True, null=True)
    tool_unit_price = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True, db_comment='�µ��ߵ���')
    coping_tool_unit_price = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True, db_comment='��ĥ������')
    notes = models.CharField(max_length=255, blank=True, null=True)
    material_add_time = models.DateTimeField(db_column='material_add__time', blank=True, null=True)  # Field renamed because it contained more than one '_' in a row.

    class Meta:
        managed = False
        db_table = 'tms_material_info_qd'



class TmsPurchaseListQd(models.Model):
    supplier = models.CharField(max_length=255, blank=True, null=True, db_comment='��Ӧ��')
    purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ���')
    bak_purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���òɹ���')
    tool_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���ߺ�')
    tool_type = models.CharField(max_length=255, blank=True, null=True, db_comment='�����ͺ�')
    tool_life = models.IntegerField(blank=True, null=True, db_comment='��������')
    tool_status = models.CharField(max_length=255, blank=True, null=True, db_comment='����״̬���µ�����ĥ��')
    cutting_edge = models.IntegerField(blank=True, null=True, db_comment='�п�')
    teeth_number = models.IntegerField(blank=True, null=True, db_comment='����')
    notes = models.CharField(max_length=255, blank=True, null=True, db_comment='��ע')
    inventory_quantity = models.IntegerField(blank=True, null=True, db_comment='�������')
    lead_time = models.FloatField(blank=True, null=True, db_comment='��������')
    safety_factor = models.FloatField(blank=True, null=True, db_comment='��ȫϵ��')
    approval_time = models.FloatField(blank=True, null=True, db_comment='����ʱ��')
    m_replace_q = models.FloatField(blank=True, null=True, db_comment='�¸�������')
    min_invent_q = models.FloatField(blank=True, null=True, db_comment='��С�������')
    actual_tool_life = models.IntegerField(blank=True, null=True, db_comment='ʵ�ʵ�������')
    purchase_time = models.DateTimeField(blank=True, null=True, db_comment='����ɹ�ʱ��')
    purchase_quantity = models.IntegerField(blank=True, null=True, db_comment='�ɹ�����')
    purchase_status = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ�״̬��δ�ɹ����ɹ��У��ѵ���')

    class Meta:
        managed = False
        db_table = 'tms_purchase_list_qd'


class TmsAddInventoryLogQd(models.Model):
    prline = models.CharField(db_column='Prline', max_length=255, blank=True, null=True)  # Field name made lowercase.
    supplier = models.CharField(max_length=255, blank=True, null=True)
    tool_number = models.CharField(max_length=255, blank=True, null=True)
    purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ���')
    bak_purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���òɹ���')
    tool_type = models.CharField(max_length=255, blank=True, null=True)
    tool_life = models.IntegerField(blank=True, null=True)
    tool_status = models.CharField(max_length=255, blank=True, null=True)
    cutting_edge = models.IntegerField(blank=True, null=True)
    teeth_number = models.IntegerField(blank=True, null=True)
    notes = models.CharField(max_length=255, blank=True, null=True)
    process_number = models.CharField(max_length=255, blank=True, null=True)
    storage_location = models.CharField(max_length=255, blank=True, null=True)
    inventory_quantity = models.IntegerField(blank=True, null=True)
    add_inventory_time = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'tms_add_inventory_log_qd'


class TmsOutInventoryLogQd(models.Model):
    prline = models.CharField(db_column='Prline', max_length=255, blank=True, null=True)  # Field name made lowercase.
    supplier = models.CharField(max_length=255, blank=True, null=True)
    tool_number = models.CharField(max_length=255, blank=True, null=True)
    purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='�ɹ���')
    bak_purchase_number = models.CharField(max_length=255, blank=True, null=True, db_comment='���òɹ���')
    tool_type = models.CharField(max_length=255, blank=True, null=True)
    tool_life = models.IntegerField(blank=True, null=True)
    tool_status = models.CharField(max_length=255, blank=True, null=True)
    cutting_edge = models.IntegerField(blank=True, null=True)
    teeth_number = models.IntegerField(blank=True, null=True)
    notes = models.CharField(max_length=255, blank=True, null=True)
    process_number = models.CharField(max_length=255, blank=True, null=True)
    storage_location = models.CharField(max_length=255, blank=True, null=True)
    inventory_quantity = models.IntegerField(blank=True, null=True)
    out_inventory_time = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'tms_out_inventory_log_qd'